//package com.innoking.docsys.config;
//
//import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
//import com.alibaba.druid.support.http.StatViewServlet;
//import com.alibaba.druid.support.http.WebStatFilter;
//import org.apache.ibatis.session.SqlSessionFactory;
//import org.mybatis.spring.SqlSessionFactoryBean;
//import org.mybatis.spring.annotation.MapperScan;
//import org.springframework.beans.factory.annotation.Qualifier;
//import org.springframework.boot.context.properties.ConfigurationProperties;
//import org.springframework.boot.web.servlet.FilterRegistrationBean;
//import org.springframework.boot.web.servlet.ServletRegistrationBean;
//import org.springframework.context.annotation.Bean;
//import org.springframework.context.annotation.Configuration;
//import org.springframework.context.annotation.Primary;
//import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
//import org.springframework.jdbc.datasource.DataSourceTransactionManager;
//
//import javax.sql.DataSource;
//
///**
// * Created by sunq on 2018/6/28.
// */
//
//@Configuration
//@MapperScan(basePackages = ReadOnlyDBConfig.PACKAGE, sqlSessionFactoryRef = "clusterSqlSessionFactory")
//public class ReadOnlyDBConfig {
//
//    // 精确到 从数据库 目录，以便跟其他数据源隔离
//    static final String PACKAGE = "com.innoking.docsys.*.dao.cluster";
//    static final String MAPPER_LOCATION = "classpath:mapper/cluster/*.xml";
//
//
//    @Bean(name = "secondaryDataSource")
//    @Qualifier("secondaryDataSource")
//    @Primary
//    @ConfigurationProperties(prefix = "spring.datasource.secondary")
//    public DataSource secondaryDataSource(){
//        return DruidDataSourceBuilder.create().build();
//        //return DataSourceBuilder.create().build();
//    }
//
//
//
//    @Bean(name = "clusterTransactionManager")
//    public DataSourceTransactionManager clusterTransactionManager() {
//        return new DataSourceTransactionManager(secondaryDataSource());
//    }
//
//    @Bean(name = "clusterSqlSessionFactory")
//    public SqlSessionFactory clusterSqlSessionFactory(@Qualifier("secondaryDataSource") DataSource clusterDataSource)
//            throws Exception {
//        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
//        sessionFactory.setDataSource(clusterDataSource);
//        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
//                .getResources(ReadOnlyDBConfig.MAPPER_LOCATION));
//        return sessionFactory.getObject();
//    }
//
//
//
////    @Bean(name = "secondaryJdbcTemplate")
////    public JdbcTemplate secondaryJdbcTemplate(@Qualifier("secondaryDataSource")DataSource dataSource){
////        return new JdbcTemplate(dataSource);
////    }
//////    @Bean(name = "thirdJdbcTemplate")
//////    public JdbcTemplate thirdJdbcTemplate(@Qualifier("thirdDataSource")DataSource dataSource){
//////        return new JdbcTemplate(dataSource);
//////    }
//
//    /**
//     * 注册一个StatViewServlet
//     */
//    @Bean
//    public ServletRegistrationBean druidStatViewServlet(){
//        //org.springframework.boot.context.embedded.ServletRegistrationBean提供类的进行注册.
//        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
//
//        //添加初始化参数：initParams
//        //IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page.
//        servletRegistrationBean.addInitParameter("deny","127.0.0.1");
//        //登录查看信息的账号密码.
//        servletRegistrationBean.addInitParameter("loginUsername","admin");
//        servletRegistrationBean.addInitParameter("loginPassword","admin");
//        //是否能够重置数据.
//        servletRegistrationBean.addInitParameter("resetEnable","false");// 禁用HTML页面上的“Reset All”功能
//        return servletRegistrationBean;
//    }
//
//    /**
//     * 注册一个：filterRegistrationBean
//     */
//    @Bean
//    public FilterRegistrationBean druidStatFilter(){
//
//        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
//        filterRegistrationBean.setName("druidWebStatFilter");
//        //添加过滤规则.
//        filterRegistrationBean.addUrlPatterns("/*");
//        //添加忽略的格式信息.
//        filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
//        return filterRegistrationBean;
//    }
//
//}
